/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : SQL Server
 Source Server Version : 10501600
 Source Host           : 127.0.0.1:1433
 Source Catalog        : My
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 10501600
 File Encoding         : 65001

 Date: 28/03/2019 15:06:31
*/


-- ----------------------------
-- Table structure for SEPM_APIS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[SEPM_APIS]') AND type IN ('U'))
	DROP TABLE [dbo].[SEPM_APIS]
GO

CREATE TABLE [dbo].[SEPM_APIS] (
  [id] int IDENTITY(1,1) NOT NULL,
  [url] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [parameter] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [Request_method] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [node_ID] int NULL,
  [type] varchar(255) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[SEPM_APIS] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [SEPM_APIS]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[SEPM_APIS] ON
GO

INSERT INTO [dbo].[SEPM_APIS] ([id], [url], [parameter], [Request_method], [node_ID], [type]) VALUES (N'1', N'https://192.168.227.136:8446/sepm/api/v1/identity/authenticate', N'{"username":"admin","password":"1qaz@WSX","domain":""}', N'POST', N'3786', N'verification')
GO

INSERT INTO [dbo].[SEPM_APIS] ([id], [url], [parameter], [Request_method], [node_ID], [type]) VALUES (N'18', N'https://192.168.227.136:8446/sepm/api/v1/policies/summary', N'', N'GET', N'3806', N'features')
GO

INSERT INTO [dbo].[SEPM_APIS] ([id], [url], [parameter], [Request_method], [node_ID], [type]) VALUES (N'10', N'https://192.168.227.136:8446/sepm/api/v1/groups', N'', N'GET', N'3786', N'features')
GO

INSERT INTO [dbo].[SEPM_APIS] ([id], [url], [parameter], [Request_method], [node_ID], [type]) VALUES (N'11', N'https://192.168.227.136:8446/sepm/api/v1/identity/authenticate', N'{"username":"admin","password":"1qaz@WSX","domain":""}', N'POST', N'3794', N'verification')
GO

INSERT INTO [dbo].[SEPM_APIS] ([id], [url], [parameter], [Request_method], [node_ID], [type]) VALUES (N'12', N'https://192.168.1.194:8446/sepm/api/v1/groups', N'', N'GET', N'3794', N'features')
GO

INSERT INTO [dbo].[SEPM_APIS] ([id], [url], [parameter], [Request_method], [node_ID], [type]) VALUES (N'13', N'https://192.168.227.136:8446/sepm/api/v1/identity/authenticate', N'{"username":"admin","password":"1qaz@WSX","domain":""}', N'POST', N'3806', N'verification')
GO

INSERT INTO [dbo].[SEPM_APIS] ([id], [url], [parameter], [Request_method], [node_ID], [type]) VALUES (N'14', N'https://192.168.1.194:8446/sepm/api/v1/identity/authenticate', N'{"username":"admin","password":"Symantec@123","domain":""}', N'POST', N'3811', N'verification')
GO

INSERT INTO [dbo].[SEPM_APIS] ([id], [url], [parameter], [Request_method], [node_ID], [type]) VALUES (N'15', N'https://192.168.1.194:8446/sepm/api/v1/computers', N'[{"group":{"id":"C533B381C0A801C26FBB238DC912D5D7"},"hardwareKey":"04CAE7E046D699F0BAA23AE5367D914C"}]', N'PATCH', N'3811', N'features')
GO

INSERT INTO [dbo].[SEPM_APIS] ([id], [url], [parameter], [Request_method], [node_ID], [type]) VALUES (N'17', N'https://192.168.227.136:8446/sepm/api/v1/identity/authenticate', N'{"username":"admin","password":"1qaz@WSX","domain":""}', N'GET', N'3818', N'verification')
GO

SET IDENTITY_INSERT [dbo].[SEPM_APIS] OFF
GO


-- ----------------------------
-- Table structure for server
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[server]') AND type IN ('U'))
	DROP TABLE [dbo].[server]
GO

CREATE TABLE [dbo].[server] (
  [id] int IDENTITY(1,1) NOT NULL,
  [host] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [user] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [password] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [port] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [community] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [object_id] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [node_ID] int NULL
)
GO

ALTER TABLE [dbo].[server] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [server]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[server] ON
GO

INSERT INTO [dbo].[server] ([id], [host], [user], [password], [port], [community], [object_id], [node_ID]) VALUES (N'11', N'192.168.1.241', NULL, NULL, NULL, N'Symantec@123', N'.1.3.6.1.2.1.1.1.0', N'3767')
GO

INSERT INTO [dbo].[server] ([id], [host], [user], [password], [port], [community], [object_id], [node_ID]) VALUES (N'13', N'192.168.227.144', NULL, NULL, NULL, N'public', N'.1.3.6.1.4.1.2021.10.1.3.1', N'3770')
GO

INSERT INTO [dbo].[server] ([id], [host], [user], [password], [port], [community], [object_id], [node_ID]) VALUES (N'15', N'192.168.1.241', NULL, NULL, NULL, N'Symantec@123', N'1.3.6.1.2.1.25.2.3.1', N'3772')
GO

INSERT INTO [dbo].[server] ([id], [host], [user], [password], [port], [community], [object_id], [node_ID]) VALUES (N'17', N'127.0.0.1', NULL, NULL, NULL, N'public', N'.1.3.6.1.2.1.1', N'3780')
GO

INSERT INTO [dbo].[server] ([id], [host], [user], [password], [port], [community], [object_id], [node_ID]) VALUES (N'18', N'192.168.1.241', NULL, NULL, NULL, N'Symantec@123', N'.1.3.6.1.2.1.25.2.2.0', N'3783')
GO

INSERT INTO [dbo].[server] ([id], [host], [user], [password], [port], [community], [object_id], [node_ID]) VALUES (N'21', N'127.0.0.1', NULL, NULL, NULL, N'public', N'.1.3.6.1.2.1.1', N'3792')
GO

INSERT INTO [dbo].[server] ([id], [host], [user], [password], [port], [community], [object_id], [node_ID]) VALUES (N'23', N'192.168.1.228', NULL, NULL, NULL, N'symantec@123', N'1.3.6.1.2.1.25.2.3.1', N'3817')
GO

INSERT INTO [dbo].[server] ([id], [host], [user], [password], [port], [community], [object_id], [node_ID]) VALUES (N'24', N'192.168.227.135', NULL, NULL, NULL, N'public', N'.1.3.6.1.2.1.1', N'3820')
GO

INSERT INTO [dbo].[server] ([id], [host], [user], [password], [port], [community], [object_id], [node_ID]) VALUES (N'25', N'192.168.227.135', NULL, NULL, NULL, N'public', N'.1.3.6.1.2.1.1.1.0', N'3822')
GO

SET IDENTITY_INSERT [dbo].[server] OFF
GO


-- ----------------------------
-- Table structure for sql_CarriedOut
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sql_CarriedOut]') AND type IN ('U'))
	DROP TABLE [dbo].[sql_CarriedOut]
GO

CREATE TABLE [dbo].[sql_CarriedOut] (
  [id] int IDENTITY(1,1) NOT NULL,
  [sql] varchar(max) COLLATE Chinese_PRC_CI_AS NULL,
  [primaryKey] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [node_ID] int NOT NULL,
  [SqlCarried] varchar(255) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[sql_CarriedOut] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [sql_CarriedOut]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sql_CarriedOut] ON
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'5', N'v+S1YnCZZEgX2F5+bCGAjcPzYvkkM3g1TyBVyy5bbyY=', N'id', N'3789', N'分页')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'7', N'zOMZhoEEZZl8zc90xffp9yaLDUwJUGC/Fuxq2mGYoI8=', N'COMPUTER_ID', N'3774', N'分页')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'8', N'Q3b1UOiKmkBFII793GzFUhy5VqB3HwxfhZRdFfGOoYwpWvP1KUyxk76UomtqZfdk7ojqWs9cg4g9jGSo+Hy53A==', N'host', N'3785', N'分页')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'9', N'n5kvHv0M1E5S0yHKbLbT6BYyfHUKWu6K8le3lrGSTa3t09vrpaDu71QiKC61BCl76e35pCi6ywKyE96tonZM2A==', N'id', N'3738', N'分页')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'10', N'Q3b1UOiKmkBFII793GzFUhy5VqB3HwxfhZRdFfGOoYzwlkH20D2RAx8PD86OZV7Wq/UcdFafCwrgUXL43rjfpg==', N'Sybase_id', N'3801', N'查询')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'13', N'KIYIZo06TRG31roYthL3TEP15tpAIn7kt6Z5A3G3+ZJC2xSF2fpueOEu9gNGdQKFDoCYzS8ESIrP6ETMyCC16aDZfWz33WpGsyZb9BeF02YM/lSa54FFGo7OG0z9MLYZEVdKt7k4OqFiWR2CbRkJNGBIESBz1Kohax7wRw1oBzk=', N'', N'3807', N'查询')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'14', N'Q3b1UOiKmkBFII793GzFUhy5VqB3HwxfhZRdFfGOoYymuPphQ/U98x11xF0Mi2k2eDloVpYlYEhPlAphukZqtg==', N'iso', N'3808', N'查询')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'15', N'aa0O0zxPfv9KNnH/dbWhgnH///+0pXaPh89hE9xxttRIRZVl//fdfv4Qbukl2oUW1w3DZ8eJUxeZWGIB8kvVtg==', N'JobId', N'3810', N'分页')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'16', N'aa0O0zxPfv9KNnH/dbWhgnH///+0pXaPh89hE9xxttRIRZVl//fdfv4Qbukl2oUWlyuRr36yCN6qneFUqNvZYQ==', N'JobId', N'3814', N'分页')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'17', N'TRRoKGTj0oG0y0v5lbfEOG456+mbLiO45DO2SM8SJMwhKdydfTq4DSxnw/1im95l0vO3muqCquFJOosXrbRtoWhGz6adXaH0a/rJMaOzDz0+k1fAarnkXTdB/2zOXvCZ', N'COMPUTER_ID', N'3827', N'分页')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'18', N'TRRoKGTj0oG0y0v5lbfEOG456+mbLiO45DO2SM8SJMyMAKOKX1wftnHycdIRUYBCuZIHU4J10T5S6MyyuM6GSmj+TZ5nRa8806i20aVt88CVfJoZ7wTRUdqZVKXG+sNp', N'user_id', N'3829', N'分页')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'19', N'TRRoKGTj0oG0y0v5lbfEOG456+mbLiO45DO2SM8SJMwhKdydfTq4DSxnw/1im95l0vO3muqCquFJOosXrbRtoVbauOaK1JeTb0xMgKL/jSzSpyu3xlzp41YHXl7HuHa/', N'id', N'3835', N'分页')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'20', N'TRRoKGTj0oG0y0v5lbfEOG456+mbLiO45DO2SM8SJMyPYmX8Pfgh9TBV2SotfIhqYRyAMX3KfK7DETIKO+QCjxhPlafLQYZUgXt3jd+dETWlPh121n50HZ6IieVw2YDV', N'', N'3837', N'查询')
GO

INSERT INTO [dbo].[sql_CarriedOut] ([id], [sql], [primaryKey], [node_ID], [SqlCarried]) VALUES (N'21', N'TRRoKGTj0oG0y0v5lbfEOG456+mbLiO45DO2SM8SJMyPYmX8Pfgh9TBV2SotfIhq9TD0SqfeOxycpPobLG4vVf3eXAeBOLV37YZL6A0XkJiU0VYUZExwQ1jSeFUN1n2zxidpA7+h0vJXbpponNAYwT3HXYBDyPTaajDcVydxP+eOFieE1hxq4E+jJjtN56nzlvA2AbVC3BPz7mYFhSJDC8CCc+LXCE/ihjcVTFTmhuUUNVrr5TYH5koFADM3unLpYRgSMHf/Vq3L2Au9q9pHu0JsElVBtEzcxBTpUdGWL9SBWEteDegh0yhERC+wRs5LgrmDW6ZR2vdIzKKcLjEh/P5l5rXmOvEpF5DV4CzOPOkRj+jRA9W+BhXSjZl2AIYFsp8d1/J7tqRPxztwr1v5FiZ9vvzDWQaNgaCbcdMZEOIJYYFzh/Ia9nPCsm25sIMnB+U9x43SrgYNbBwl8gNgTbYqRz39H7tk3lcQ3KWG8frzU8yLF1hh/FZj7f/kC6QuauYfOyuG4QmKo7RjjkCswRxOabxz4EwuEMw1mQOq7OsTpjrDbQcmbnkOoV2FxgAlrcMGY+HyI6FA8kjqzRicv0Gc3oVvulH4iz+mrLIko5R+udiUbgRuIYTfHbu0yyUs3AMHf5g0+Zge00Eee4pB625SrFuJyELqa3YtOa6r2NM2KHAddINvwgDaZokPGzUyZmjdCJwcTGJGdURXZ6SCweXB500ZCsMh+XxJ5v31DxBe2BFtq1pKUYG+www2VRBNTs4LFh9AVXRHkVWkS7PjEIgGJIRN6Ky3CxiKOM//jwQWUQNDkowMmtdYKuncyFDHatmT5JpHUAITfOI2WIB8h7osB0A8VBhNVklL7/PzT2fTaCsNLIGI3m1sTu5YC3DFnAuw6LXly2ICtPW8QhXLfHMO1lqwHdm6y9+GShBFaHo8c8ZghZojhBFl5fQ3avcMzMdsWAqNX0fbWnWk85WK1Erno78amvk+mb6M0X/Pk6Ad8J23qBgh63fx2AXvqIxfZXYC4412yDdCUl+c+i6zhOTkiqDlDpmc8XAnsNizA3M9S8S2j7aFEakzB0W9OVWX', N'person_id', N'3838', N'分页')
GO

SET IDENTITY_INSERT [dbo].[sql_CarriedOut] OFF
GO


-- ----------------------------
-- Table structure for tree
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tree]') AND type IN ('U'))
	DROP TABLE [dbo].[tree]
GO

CREATE TABLE [dbo].[tree] (
  [id] int IDENTITY(1,1) NOT NULL,
  [pId] int NULL,
  [name] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [type] int NULL,
  [open] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [nodeGuid] varchar(255) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[tree] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [tree]
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tree] ON
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3728', N'0', N'数据库数据展示', NULL, N'true', NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3738', N'3728', N'tree', N'1', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3757', N'0', N'veritas', NULL, N'false', NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3758', N'3771', N'界面（数据源227.128）', N'2', N'true', NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3763', N'0', N'snmp', NULL, N'false', NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3765', N'3771', N'数据源', N'4', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3767', N'3825', N'系统基本信息192.168.1.241', N'3', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3771', N'3757', N'磁带生命周期管理', NULL, N'false', NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3772', N'3825', N'一体机_ALL', N'3', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3773', N'3757', N'OpsCenter数据分析', NULL, N'false', NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3774', N'3830', N'(视图方式)pfyh_script.computer_ALL', N'1', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3777', N'3773', N'new node3', NULL, NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3780', N'3763', N'MyComputer', N'3', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3781', N'3819', N'SEPM_APIS', NULL, N'true', NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3783', N'3825', N'一体机测试', N'3', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3785', N'3830', N'nbu数据爬取参数表', N'1', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3786', N'3781', N'(获取所有组)/api/v1/groups', N'6', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3789', N'3830', N'SEPM_APIS参数表a', N'1', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3794', N'3781', N'v1/groups/{groupId}', N'6', NULL, NULL)
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3801', N'3830', N'1.27 JOBD_Job_Sybase', N'1', NULL, N'{AB770F4B-51EB-CBCB-002B-3523DCC19BC9}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3806', N'3781', N'v1/policies/summary', N'6', NULL, N'{D5BDC934-47A5-B8A5-97C7-2CB01A8EB706}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3807', N'3830', N'memory_disk_SNMP', N'1', NULL, N'{52995E4D-D1A7-BF9D-45B2-B0D6C1153423}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3808', N'3830', N'cpu_SNMP', N'1', NULL, N'{4ED3E747-7B47-150D-A9AE-1FF3025535DD}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3810', N'3816', N'tasit5230_JOBD_Job', N'1', NULL, N'{B69CC600-ED79-0349-E44A-5E70E4208806}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3811', N'3781', N'PATCH Computer', N'6', NULL, N'{8064E198-EB10-BE1F-4407-FC119AC3651D}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3814', N'3816', N'nbumaster_JOBD_Job', N'1', NULL, N'{0BB5861D-4F9F-5FBE-D756-A4DF68A6D624}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3816', N'3830', N'VERITAS_NBU', NULL, N'false', N'{7D42AD89-D041-BC8B-3B83-D4AE2EF6EE3A}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3817', N'3825', N'228', N'3', N'true', N'{C1E40AF9-F6F3-3411-979B-E9AB38C76AAE}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3818', N'3781', N'test', N'6', NULL, N'{540EF946-67F7-5166-A98B-3C0F96E64043}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3819', N'0', N'HTTP请求', NULL, N'false', N'{F0B3B25A-4118-2799-47CF-0A6DFEA29D85}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3820', N'3763', N'系统基本信息227.135', N'3', NULL, N'{64FEEA4F-6641-8A4D-594E-5CFC49C45C44}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3822', N'3763', N'系统版本227.135', N'3', NULL, N'{F6EDEC58-EFFF-4889-6848-04990520DA18}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3825', N'3763', N'VERITAS NBU服务器', NULL, N'true', N'{3E1BA13A-1650-B762-F343-791316C19633}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3826', N'3728', N'Mysql', NULL, N'false', N'{E9B67CC0-3021-D7F8-BD78-9C9500F10DB6}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3827', N'3826', N'pfyh_computer', N'1', NULL, N'{44689204-C8FB-406F-C196-E7C556CA5B48}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3828', N'3728', N'bugclose', NULL, N'true', N'{652B74C9-8A6A-D445-0C27-A45E68603374}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3829', N'3828', N'user', N'1', NULL, N'{66501C51-E4DF-7F33-158A-26AD64039615}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3830', N'3728', N'废弃', NULL, N'false', N'{41E6AB18-F5B2-9A18-742D-DB6C8092BDF4}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3833', N'3817', N'new node1', N'6', NULL, N'{F96A1F65-1351-3905-88C1-566F06208823}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3834', N'0', N'比赛助手V3', NULL, N'true', N'{1D286C35-0A83-0CE8-8A17-53AA906FC143}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3835', N'3834', N'测试', N'1', NULL, N'{31C98CCF-4566-A8EF-67B1-394F75FC22EC}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3836', N'0', N'比赛助手V3-测试', NULL, NULL, N'{23AD9071-1E8F-64BF-43A1-895EF7C72839}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3837', N'3834', N'new node2', N'1', NULL, N'{DEE06D4B-FF6B-AB8A-9DAA-41BD456F54F3}')
GO

INSERT INTO [dbo].[tree] ([id], [pId], [name], [type], [open], [nodeGuid]) VALUES (N'3838', N'3834', N'new node3', N'1', NULL, N'{04576F44-6821-B33C-C369-767868876052}')
GO

SET IDENTITY_INSERT [dbo].[tree] OFF
GO


-- ----------------------------
-- Primary Key structure for table server
-- ----------------------------
ALTER TABLE [dbo].[server] ADD CONSTRAINT [PK__server__3213E83F060DEAE8] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sql_CarriedOut
-- ----------------------------
ALTER TABLE [dbo].[sql_CarriedOut] ADD CONSTRAINT [PK__sql_Carr__3213E83F2E1BDC42] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tree
-- ----------------------------
ALTER TABLE [dbo].[tree] ADD CONSTRAINT [PK__tree__3213E83F00551192] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

